oracle rac 12c best practices

Tags: command execution wget Restart Speed Hyper Fusion is open OGGOracle 12c was released for a long time, although several sets of single-instance Oracle 12c have been deployed in the near future, there has been no opportunity to implement 12c RAC in the production environ

Oracle Study--oracle 12c RAC Install (ii) Third, install the grid infrastructure 1. Install GI software [Root@node1 grid]#./runinstaller 2. Run the script [root@node1 cvu_12.1.0.2.0_grid]#/u01/app/orainventory/orainstroot.sh changing permissions of/u01/app/orainventory. Adding Read,wri

4096dec1101:02racgdrwxr-x---2gridoinstall4096dec 1101:02srvmdrwxrwxr-x2gridoinstall4096dec1101:02 xag[[emailprotected]rac1]$However, in the 12c, there is still the above directory structure, but there is nothing in the content. Since 12c, the log structure of the RAC has changed.There are two types of RAC in

Turn RAC off (Oracle 12C note) Turn RAC off (Oracle 12C note) Check RAC status [Grid @ rac01 ~] $ Crsctl check crs CRS-4638: Oracle High Ava

The obsolete maintenance command crs _ *, 12ccrs _ in Oracle 12c RAC _ Crs_stat is commonly used in Oracle 10g and 11g RAC to monitor the running status of RAC. However, the crs_stat display is incomplete, so we will perform a

Look at me today this single node 12C RAC, suddenly feel that the disk group of OCR is called +dg_sys a little uncomfortable, want to change to +SYS_DG. The approach is to migrate the Ocr/votedisk/asm SPFile to an existing ASM, and then modify the disk group name and finally migrate to the new name Disk group (this process +DG_SYS-GT;+DATA-GT;+SYS_DG)Current operating conditions[Grid@xifenfei ~]$ crsctl sta

Tags: Oracle 12c Three-node RAC installation error [ins-32025]Test installs three node Oracle 12C RAC, notebook configuration dual core I5 16g memory, each VM allocates 4G memory.During the installation of the database software, t

Tags: openfiler 12c oss sha Hyper-converged to address ADO RAC improvementsWith a lot of Oracle RAC, shared storage is used. Dual controller with full disk, 15000 rpm SAS full slot, made into RAID 10, the cost is still very large. Recently in the open source hyper-fusion test, has achieved the very ideal effect: to be

!Aboutdave:--------------------------------------------------------------------------------------------qq:251097186Email: [email protected]Blog:http://blog.csdn.net/tianlesoftwareWeibo:http://weibo.com/tianlesoftwareTwitter:http://twitter.com/tianlesoftwareFacebook:http://www.facebook.com/tianlesoftwareLinkedin:http://cn.linkedin.com/in/tianlesoftwareDave's QQ Group:--------------------------------------------------------------------------------------------Note: Add group must indicate tablespac

Deep understanding of Oracle RAC 12cJump to: Navigation, search Directory 1 Overview 2 Cluster parts management and fault diagnosis 3 Operational Practices 4 new Features 5 Storage and ASM 6 problems in application design 7 managing and tuning a complex RAC e

First, the environmentService side: Oracle 12.2.0.1 RACClient: Less than Oracle 11.2.0.3Second, the phenomenonWhen using a less than Oracle 11.2.0.3 client version connection to the Oracle 12.2.0.1 RAC database "Ora-28040:no matching authentication protocol"Third, solve the

Tags: oracle 12C RAC cluster log ([Email protected] ~]$ AdrciAdrci:release 12.2.0.1.0-production on Thu Mar 1 09:25:45 2018Copyright (c) 1982, Oracle and/or its affiliates. All rights reserved.ADR base = "/u01/u01/grid"Adrci> Show HomesADR Homes:diag/asm/user_root/host_3751460993_107diag/asm/user_grid/host_3751460993_1

/asm-diskechmod 660/DEV/ASM-DISKFchmod 660/dev/asm-diskgForgot to edit the kernel parameters vi/etc/sysctl.confFs.file-max = 6815744Kernel.sem = 250 32000 100 128Kernel.shmmni = 4096Kernel.shmall = 4294967296Kernel.shmmax = 4398046511104Kernel.panic_on_oops = 1Net.core.rmem_default = 262144Net.core.rmem_max = 4194304Net.core.wmem_default = 262144Net.core.wmem_max = 1048576FS.AIO-MAX-NR = 1048576Net.ipv4.ip_local_port_range = 9000 65500This article is from the "vmware/

SOURCE end: 12C RAC primay backup fileTarget side: 12C Single InstancePartial Summary:1 Pfile Modification2 Disable Redo Thread N3 Drop logfile Group N4 Rename LogFile5 Cancel Log Remote transferIf primary is in Maximum availablity mode, the control file will detect log_archive_dest_n in case the log transfer is normal? So without processing will be an error:LGWR

. Executes the root.sh script after the installation is complete.3.1. Run the installation script$Grid _home/gridsetup. SH3.2. Select Configure Grid Infrastructure for a New Cluster and click Next3.3. Select Configure an Oracle Standalone Cluster, then click Next3.4.scan-name to be the same as Scan-ip in/etc/hosts, cancel the GNS and click Next3.5. Choose Add node, fill in Public-ip and virtual-ip hostname, then select all nodes, click SSH connectivit

This article describes how to build a Acfs file system on a virtual machine that already has 12c RAC installed, and use the ACFS snapshot to brush a cow (Copy-On-Write) library to do the test library. Highlight Step: Add ASM disk to virtual machine to build Acfs file systemSecond, create Acfs file systemThird, create the database on the Acfs file system in Node 1. (12